package org.dbstar.scheduler.control.db.dependency;

import java.sql.Types;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.SqlParameter;

/**
 * 按照JobConf Identifier查询JobDependency
 * 
 * @author 代波
 * @since 1.0.0
 * @version 1.0.0
 * @date 2012-6-14
 */
public class JobDependencyQueryByConf extends JobDependencyQuery {
	public JobDependencyQueryByConf(JdbcTemplate jt) {
		super(jt, "WHERE CONF_SYSTEM_IDENTIFIER = ? AND CONF_SEQUENCE = ? ORDER BY SYSTEM_IDENTIFIER, SEQUENCE");
		declareParameter(new SqlParameter("CONF_SYSTEM_IDENTIFIER", Types.VARCHAR));
		declareParameter(new SqlParameter("CONF_SEQUENCE", Types.INTEGER));
	}
}
